package cn.gson.springboot.model.dao;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import cn.gson.springboot.model.pojos.Redetai;

public interface RedetaiDAO extends CrudRepository<Redetai, Integer> {
	@Query("SELECT SUM(a.redetaiNumberYf) as redetaiNumberYf from Redetai as a where a.drugsYk.drugId=?1 and a.yppc=?2")
	public Object[] cxtysy(int a,int b); 
}
